<%-- 
    Document   : update
    Created on : Jun 20, 2012, 7:01:32 AM
    Author     : karuna
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">
   <%@page import="java.sql.*,java.io.*" %>
  <%
          Class.forName("oracle.jdbc.driver.OracleDriver");

         Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","pac","mca"); 

         Statement stmt=con.createStatement();
         String student_id=request.getParameter("student_id");
    String college_code=request.getParameter("college_code");
    String question=request.getParameter("question");
    String company_name=request.getParameter("company_name");
            PreparedStatement pstmt1=con.prepareStatement("insert into imp_stu values(?,?,?,?)");
    
    
   pstmt1.setString(1,student_id);
    pstmt1.setString(2,college_code);
     pstmt1.setString(3,question);
     pstmt1.setString(4,company_name);
    
     pstmt1.executeUpdate();
%>  



<html>
    <body>
    <center>
        <table height="100" width="50" bdcolor="grey">
            <tr><td> message forwarded sucessfully </td></tr>
            <tr><td><br></td></tr>
            <tr><td><br></td></tr>
            <tr><td><br></td></tr>
        </table>
        
        
    </center>
</body>
</html>
